home *** CD-ROM | disk | FTP | other *** search
/ Magnum One / Magnum One (Mid-American Digital) (Disc Manufacturing).iso / d6 / sale_a27.arc / MERGE.DOC < prev    next >
Text File  |  1989-01-03  |  7KB  |  174 lines
  1.            WordStar/MailMerge[TM]/Basica/Output Sequential File
  2.                  WordPerfect[TM] Merge and dBASE III [TM] 
  3.                      and Microsoft [Reg. TM] Word 4.0
  4.  
  5.                                   OVERVIEW
  6.  
  7. Thesσá option≤ creatσ eithe≥ ß WordStar/MailMerge[TM]¼á WordPerfect[TM]¼á o≥ ì
  8. dBAS┼á II╔ [TM▌ datß filσ usinτ thσ datß froφ you≥ Prospect/dBAS┼ II╔á file« ì
  9. Thσ newl∙ createΣ filσ end≤ iε thσ letters║ '.DAT'¼ .DEF'¼ '.SFº o≥ '.DBF'.
  10.  
  11. Iµ useΣ witΦ Wordstar[TM]¼á thσ .DA╘ filσ caε bσ useΣ t∩ prin⌠ forφá letter≤ ì
  12. iεá MailMerge[TM]«á  Al∞ characte≥ field≤ arσ  trimmeΣ oµ trailinτ blank≤ t∩ ì
  13. accommodatσá you≥ forφ letters«á   Alonτ witΦ thi≤ datß file¼á thσá Wordsta≥  ì
  14. optioεá create≤á thσ beginninτ oµ  you≥ forφ lette≥ anΣ put≤ i⌠á iεá ßá filσ ì
  15. endinτá iεá thσ │ letter≤ '.DEFº (containinτ al∞ thσ MailMerge[TM▌á command≤ ì
  16. yo⌡ neeΣ a⌠ thσ star⌠ oµ ß forφ letter)« 
  17.  
  18. Iµá useΣá witΦ WordPerfect[TM]¼á thσ .S╞ filσ i≤ thσ 'Secondar∙á Fileºá tha⌠  ì
  19. WordPerfec⌠á use≤á fo≥ mergσ letters¼á  wherσ eacΦ fielΣ i≤á delimiteΣá witΦ ì
  20. CONTROL-R¼ anΣ eacΦ recorΣ i≤ delimiteΣ witΦ CONTROL-E.]
  21.  
  22. Iµ useΣ witΦ dBAS┼ II╔ [TM]¼á thσ '.DBFº filσ forma⌠ i≤ becominτ ßá standarΣ ì
  23. datßá filσá forma⌠ tha⌠ man∙ othe≥ program≤ arσ usinτ fo≥á thei≥á respectivσ ì
  24. datß impor⌠ function.
  25.  
  26. Wheε useΣ witΦ Microsof⌠ [Reg«á TM▌ WorΣ 4.0¼á thσ '.DATº filσ contain≤ thσ ì
  27. datß o≥ record≤ tha⌠ thσ WorΣ 4.░ mergσ documen⌠ requires« 
  28.  
  29.  
  30.  
  31. Thesσ option≤  wil∞ allo≈ yo⌡ t∩ outpu⌠ thσ ke∙ field≤ iε you≥ prospec⌠ filσ ì
  32. t∩ aε externa∞ tex⌠ filσ tha⌠ can¼á iε turn¼á bσ useΣ b∙ ß worΣ processo≥ t∩ ì
  33. creatσ 'boilerplateº o≥ forφ letter≤ fo≥ yo⌡ automatically.
  34.  
  35. BaseΣá oε you≥ selectioε criteria¼á iµ any¼á thσ prograφ wil∞á outpu⌠á thesσ ì
  36. fields║ 
  37.      Se° ID¼ Firs⌠ name¼ Greeting, Las⌠ name¼ Compan∙ Name¼ Address1/2
  38.                   City¼ State¼ Zip¼ Phonσ number¼ Comment≤ 
  39.  
  40.  
  41.                                ==============
  42.                                |  OPTION 1: |
  43.                                ==============
  44.  
  45.                              Selection Process:
  46.  
  47. A⌠ optioε 1¼ yo⌡ caε inpu⌠ u≡ t∩ ╖ searcΦ criteriß a≤ thσ basi≤ fo≥ 
  48. you≥ worΣ processo≥ mergσ file║ 
  49.  
  50.              Las⌠ Name¼ Firs⌠ Name¼ Company¼ City¼ State¼ Zip¼ 
  51.                                anΣ Comments.
  52.  
  53. Yo⌡á caεá selec⌠ whethe≥ yo⌡ wan⌠ onl∙ thosσ record≤ t∩  bσ  selecteΣá  tha⌠  ì
  54. havσá al∞ oµ criteriß iε ever∙ recorΣ o≥ selec⌠ ou⌠  record≤á regardles≤á oµ ì
  55. thσá numbe≥ oµ  matche≤ madσ pe≥ record¼á  a≤ lonτ a≤ a⌠  leas⌠ onσ matcΦ i≤ ìèmadσ iε an∙ onσ recorΣ tha⌠ i≤ selected.
  56.  
  57. Truσ  [o≥ T▌ mean≤ al∞ matche≤ havσ t∩ bσ madσ iε an∙ onσ recorΣ fo≥ i⌠  t∩ 
  58. bσ  selected«   Falsσ  [o≥ F▌ mean≤ tha⌠ a≤ lonτ a≤ onσ matcΦ i≤ madσ iε  ß 
  59. recorΣ i⌠ wil∞ bσ selected.
  60.  
  61.  
  62.  
  63.                          Search Criteria Selection:
  64.                                  Option 1:
  65.  
  66. Yo⌡ caε ente≥ an∙ word¼á  phrase¼  o≥ codσ oε whicΦ t∩  basσ you≥ selection«  ì
  67. Iµá lef⌠ blank¼á  al∞ record≤ wil∞ bσ selecteΣ out«á   Iµ yo⌡ makσ aεá entr∙ ì
  68. here¼á  thσá prograφ wil∞ searcΦ througΦ thσ prospec⌠ filσ  anΣ  selec⌠á ou⌠ ì
  69. onl∙ thosσ record≤ tha⌠ mee⌠ you≥ searcΦ criteria.
  70.  
  71. [Notσ tha⌠ yo⌡ caε havσ u≡ t∩ ╖ differen⌠ code≤ o≥ phrase≤ entereΣ herσá anΣ ì
  72. al∞á  record≤ wil∞ bσ pulleΣ whicΦ havσ an∙ onσ oµ theφ  o≥ an∙  combinatioε ì
  73. oµ them]
  74.  
  75.                                ==============
  76.                                |  OPTION 2: |
  77.                                ==============
  78.                 2)  Output records to Wordstar/Mailmerge[TM]  
  79.  
  80. Thi≤á optioε i≤ useΣ t∩ ge⌠ datß froφ thσ Prospec⌠ filσ anΣ outpu⌠ i⌠á t∩á ß ì
  81. filσá tha⌠á caε bσ useΣ b∙ WordStar/MailMerge[TM]«á  Thi≤  filσ caε als∩á bσ ì
  82. useΣ b∙ BASI├ anΣ othe≥ language≤ anΣ products«á Iε short¼á an∙ produc⌠ tha⌠ ì
  83. accept≤á "commß delimitedó file≤ fo≥ inpu⌠ ma∙ accep⌠ thσ  filσá createΣá b∙ ì
  84. thi≤ option.
  85.  
  86. Froφ thσ WordSta≥ option¼á yo⌡ wil∞ creatσ  tw∩ files«á  Thσ firs⌠ filσ namσ ì
  87. end≤á iεá .DE╞ anΣ i≤ ß filσ tha⌠ caε bσ turneΣ int∩ ß forφ lette≥á jus⌠á b∙ ì
  88. callinτá i⌠ u≡ iε WordSta≥ anΣ matchinτ i⌠ t∩ you≥ forφ letter«á  I⌠ alread∙ ì
  89. contain≤á al∞ oµ thσ command≤ needeΣ b∙ WordSta≥ t∩ reaΣ thσá Prospect/dBAS┼ ì
  90. II╔ datß filσ (.DAT).
  91.  
  92. Thσ othe≥  filσ i≤ thσ .DA╘ file¼á whicΦ contain≤ al∞ datß tha⌠ yo⌡ wan⌠á t∩ ì
  93. reaΣá int∩ WordStar«á  I⌠ i≤ formatteΣ sequentia∞ file¼á witΦ al∞ field≤á iε ì
  94. quote≤ anΣ separateΣ b∙ commas« 
  95.  
  96.  
  97.                                ==============
  98.                                ⁿ  OPTIO╬ 3║ |
  99.                                ==============
  100.  
  101.                    3)  Output records to WordPerfect[TM] 
  102.  
  103. Thσá .S╞á filσá i≤á thσ 'Secondar∙ Fileº tha⌠  WordPerfec⌠á use≤á fo≥á mergσ ì
  104. letters¼á  wherσ eacΦ fielΣ i≤ delimiteΣ witΦ CONTROL-R¼á anΣ eacΦ recorΣ i≤ ì
  105. delimiteΣ witΦ CONTROL-E.]
  106.  
  107.  
  108.  
  109.                                ==============è                               |  OPTION 4: |
  110.                                ==============
  111.  
  112.                4)  Output records to dBASE III [Registered TM]
  113.  
  114.  
  115. WitΦá optioεá 4¼á thσ '.DBFº filσ forma⌠ i≤ becominτ ßá standarΣá datßá filσ ì
  116. forma⌠á tha⌠ man∙ othe≥ program≤ arσ usinτ fo≥ thei≥ respectivσ datßá impor⌠ ì
  117. function«  
  118.  
  119. Oncσá yo⌡ assigε ß namσ t∩ thσ dBAS┼ II╔ [TM▌ filσ yo⌡ arσá outputting¼á thσ ì
  120. structurσ oµ tha⌠ filσ is:
  121.  
  122. Field  Field Name  Type       Width    Dec
  123.     1  SEX         Character     19
  124.     2  FNAME       Character     20
  125.     3  GREETING    Character     20
  126.     4  LNAME       Character     20
  127.     5  PROSPECT    Character     40
  128.     6  ADDRESS1    Character     30
  129.     7  ADDRESS2    Character     30
  130.     8  CITY        Character     30
  131.     9  STATE       Character      2
  132.    10  ZIP         Numeric        5
  133.    11  ZIP4        Numeric       4
  134.    12  PHONE_1     Character     13      
  135.    13  COMMENT1    Character     60  
  136.    14  COMMENT2    Character     60     
  137.  
  138. ** Total **                     354  
  139.  
  140.  
  141.  
  142.                                ==============
  143.                                |  OPTION 5: |
  144.                                ==============
  145.                5)  Output records to Microsoft [TM] Word 4.0
  146.  
  147. Thi≤á optioε i≤ useΣ t∩ ge⌠ datß froφ thσ Prospec⌠ filσ anΣ outpu⌠ i⌠ t∩á ß ì
  148. datß filσ tha⌠ caε bσ useΣ b∙ thσ mergσ featurσ iε WorΣ 4.0..
  149.  
  150. You≥ WorΣ 4.░ lette≥ wil∞ contaiε mergσ variable≤ oµ thσ form:
  151.  
  152.                                   <<SEX>>
  153.                                  <<FNAME>>
  154.                                <<GREETING>>
  155.                                  <<LNAME>>
  156.                                <<PROSPECT>>
  157.  
  158. anΣá s∩ on«á  Thesσ mergσ variable≤ arσ identifieΣ iε thσ '.DEFº o≥á heade≥ ì
  159. filσ createΣ b∙ thσ program«á  Thesσ symbols¼á "<<ó anΣ ">>"¼ arσ formeΣ b∙ ì
  160. holdinτ dowε thσ <ALT╛ ke∙ anΣ typinτ 17┤ o≥ 175.
  161.  
  162.  
  163. A⌠á thσá to≡ oµ you≥ WorΣ 4.░ letter¼á yo⌡ wil∞ havσ thi≤ commanΣá (iµá yo⌡ ìèselec⌠ 'TESTº a≤ thσ filσ namσ fo≥ outputtinτ you≥ datß iε optioε 5):
  164.  
  165. <<DATA TEST.DEF, TEST.DAT>>
  166.  
  167. Thi≤á tell≤ WorΣ 4.░ t∩ looδ int∩ TEST.DE╞ fo≥ thσ heade≥ o≥ identificatioε ì
  168. oµ field≤ used╗ anΣ t∩ pul∞ iε TEST.DA╘ fo≥ thσ data.
  169.  
  170. TEST.DA╘ i≤ ß 'commß delimited¼ ASCI╔ file'«  I⌠ contain≤ al∞ datß tha⌠ yo⌡ ì
  171. wan⌠á t∩ reaΣ int∩ WorΣ 4.0«á  I⌠ i≤ formatteΣ sequentia∞á file¼á witΦá al∞ ì
  172. field≤ iε quote≤ anΣ separateΣ b∙ commas« 
  173.  
  174.